www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/tsm.cpp
// tsm.cpp : implementation file // #include "stdafx.h" #include "khmanager.h" #include "tsm.h" #include "ado.h" #include "khts.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // tsm dialog tsm::tsm(CWnd* pParent /*=NULL*/) : CDialog(tsm::IDD, pParent) { //{{AFX_DATA_INIT(tsm) // NOTE: the ClassWizard will add member initialization here //}}AFX_DATA_INIT } void tsm::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(tsm) DDX_Control(pDX, IDC_LIST1, m_list); DDX_Control(pDX, IDC_COMBO1, m_com); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(tsm, CDialog) //{{AFX_MSG_MAP(tsm) ON_BN_CLICKED(IDC_BUTTON1, OnButton1) ON_BN_CLICKED(IDC_BUTTON2, OnButton2) ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1) ON_NOTIFY(LVN_COLUMNCLICK, IDC_LIST1, OnColumnclickList1) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // tsm message handlers BOOL tsm::OnInitDialog() { CDialog::OnInitDialog(); ado rst; rst.Open("select * from tb_Client_khmyd",adCmdText); int rstnum=rst.GetRecordCount(); int i; for(i=1;i<=rstnum;i++) { this->m_com.AddString(rst.GetFieldValue("khmyd_myd")); rst.Move(i); } rst.close(); m_list.ModifyStyle(0L,LVS_REPORT); // m_list.ModifyStyle(0L,LVS_SINGLESEL); m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS); m_list.ModifyStyle(0L,LVS_NOSORTHEADER); m_list.SetExtendedStyle(LVS_EX_GRIDLINES| LVS_EX_FULLROWSELECT| LVS_EX_HEADERDRAGDROP| LVS_EX_ONECLICKACTIVATE); m_list.EnableAutomation(); m_list.InsertColumn(0,"区域编号"); m_list.InsertColumn(1,"区域名称"); m_list.InsertColumn(2,"区域级别"); m_list.InsertColumn(3,"区域重要程度"); m_list.InsertColumn(4,"区域购买力描述"); m_list.InsertColumn(5,"备注信息"); m_list.SetColumnWidth(0,100); m_list.SetColumnWidth(1,100); m_list.SetColumnWidth(2,100); m_list.SetColumnWidth(3,100); m_list.SetColumnWidth(4,100); m_list.SetColumnWidth(5,100); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void tsm::OnButton1() { this->EndDialog(true); } void tsm::loadlist() { ado rst; rst.rstOpen("select * from tb_Client_khts"); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("khts_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("khts_qymc")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("khts_tsr")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("khts_tszt")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("khts_tsnr")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("khts_tsrq")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("khts_clbf")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("khts_khmyd")); m_list.SetItemText(ii-1,8,rst.GetFieldValue("khts_tsslr")); m_list.SetItemText(ii-1,9,rst.GetFieldValue("khts_bz")); rst.Move(ii); } rst.close(); } void tsm::OnButton2() { this->m_list.DeleteAllItems(); CString com,sql; this->m_com.GetWindowText(com); if(com.IsEmpty()) {MessageBox("请选择","提示"); return; } sql.Format("select * from tb_Client_khts where khts_khmyd='%s'",com); ado rst; rst.Open(sql,adCmdText); int recordcount=rst.GetRecordCount(); int ii; for(ii=1;ii<=recordcount;ii++) { m_list.InsertItem(ii-1,""); m_list.SetItemText(ii-1,0,rst.GetFieldValue("khts_id")); m_list.SetItemText(ii-1,1,rst.GetFieldValue("khts_qymc")); m_list.SetItemText(ii-1,2,rst.GetFieldValue("khts_tsr")); m_list.SetItemText(ii-1,3,rst.GetFieldValue("khts_tszt")); m_list.SetItemText(ii-1,4,rst.GetFieldValue("khts_tsnr")); m_list.SetItemText(ii-1,5,rst.GetFieldValue("khts_tsrq")); m_list.SetItemText(ii-1,6,rst.GetFieldValue("khts_clbf")); m_list.SetItemText(ii-1,7,rst.GetFieldValue("khts_khmyd")); m_list.SetItemText(ii-1,8,rst.GetFieldValue("khts_tsslr")); m_list.SetItemText(ii-1,9,rst.GetFieldValue("khts_bz")); rst.Move(ii); } rst.close(); } void tsm::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) { int i=m_list.GetHotItem(); if(i<0) {return;} khts ts; ts.edit1=this->m_list.GetItemText(i,0); ts.edit2=this->m_list.GetItemText(i,1); ts.edit3=this->m_list.GetItemText(i,2); ts.edit4=this->m_list.GetItemText(i,3); //ts.edit5=this->m_list.GetItemText(i,4); ts.edit6=this->m_list.GetItemText(i,4); ts.edit7=this->m_list.GetItemText(i,5); ts.edit8=this->m_list.GetItemText(i,6); ts.DoModal(); *pResult = 0; } void tsm::OnColumnclickList1(NMHDR* pNMHDR, LRESULT* pResult) { NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR; // TODO: Add your control notification handler code here *pResult = 0; }